<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="java.util.*" %>
<%@ page import="com.ionglobal.db.*" %>
<%@ page import="com.ionglobal.lib.*" %>
<%@ page import="com.ionglobal.misc.*" %>

<%@ include file="../init_include.jsp" %>

<%
	Integer catId;
	int totalpages,pageid=0;
	int pagerows=Page.getPageRows();
	int totalUsers=0;
	int titleMaxLen=20;
  String ordermode="";
  String orderfield="";
  
	Sysop sysop=(Sysop)session.getAttribute("sysop");	
	int groupid = 0;
	try {
		if (request.getParameter("id")!=null)
			groupid=Integer.parseInt(request.getParameter("id"));
	}	catch(NumberFormatException e) {
		return ;
	}	
		
	int check_rst=Permission.accept(dbi,session,request,"sysop","tree","catid","000000010"); 
	if (check_rst!=Permission.CHECK_RST_SUCCESS) {
		dbi.closeAll();
		if (check_rst==Permission.CHECK_RST_DENY)
			response.sendRedirect("../deny.html");
		else
			response.sendRedirect("../index.jsp");
		return;		
	}

	if(request.getParameter("ordermode")!=null)
		ordermode=request.getParameter("ordermode");	
	if(request.getParameter("orderfield")!=null)
		orderfield=request.getParameter("orderfield");		

	String whereClause="";
	if(request.getParameter("whereClause")!=null)
		whereClause=request.getParameter("whereClause");	
	whereClause=whereClause.trim();

	
	String a=request.getParameter("catid");
	String str="";
	try {
		catId=Integer.valueOf(a);		
	}	catch(NumberFormatException e) {
		out.println(e+"catId");
		return;
	}
	
	try {
		if (request.getParameter("pageid")!=null)
			pageid=Integer.parseInt(request.getParameter("pageid"));
		else
			pageid=1;
	}	catch(NumberFormatException e) {
		out.println(e+"pageid");
		pageid=1;
	}	
	
	try {
		if (request.getParameter("pagerows")!=null)
			pagerows=Integer.parseInt(request.getParameter("pagerows"));
	} catch(NumberFormatException e) {
		out.println(e+"pagerows");
	}	

	totalUsers=GroupRole.getGroupRoleNum(dbi,groupid,whereClause);
	totalpages = (int)Math.ceil((double)totalUsers/pagerows);
	if(pageid>totalpages)
		pageid=totalpages;
	if(pageid<=1)
		pageid=1;
%>	
<html>
<head>
<title><%=Language.getNameByCode("sys.role.title","Role And Privilege")%></title>
<meta http-equiv="Content-Type" content="text/html; charset=<%=Language.getHTMLLanguageStr()%>">
<link rel="stylesheet" href="../css.css" type="text/css">
<SCRIPT language=JavaScript1.2 src="../script/Ion_Show.js"></SCRIPT>
<script language="javascript">
<!--
	function Ion_Del()
	{
		deleteIon('vmsSelectFrame.jsp','roleCategory_deleteByGroup.jsp','<%=Language.getNameByCode("sys.class","Group ")%>');
	}

	function Ion_Add()
	{
		add_Ion('vmsSelectFrame.jsp','../sys/roleCommission_djByGroup.jsp','groupid');
	}
	
	function Ion_Search()
	{
		add_Ion('vmsSelectFrame.jsp','../sys/roleCommission_searchByGroup.jsp','groupid');
	}	
-->
</script>
</head>

<body bgColor=#d6d3ce leftMargin=0 
style="BORDER-BOTTOM: 0px outset; BORDER-LEFT: 0px outset; BORDER-RIGHT: 0px outset; BORDER-TOP: 0px outset" 
topMargin=0>

<FORM name="formIon" method="post" action="?" onsubmit="">
<table width="100%" border="0" cellspacing="1" cellpadding="2">
  <tr>
    <td class="nagivation" colspan="2"><%=Language.getNameByCode("sys.CurrentPos","Current Position")%>:<% 
    Vector vcpath=Category.getLadder(session,"tree",(catId.intValue()));
		out.print(Category.getFullPath(vcpath));
		UserTreeManager utm = new UserTreeManager();
		utm.setSqlNode( "select id,name,parentid,layer from sys_class" );
		Vector aavc = utm.getAllAncestors( dbi, groupid );
		boolean href = false;
		for( int i = 0; i < aavc.size(); i++ ){
			UserTreeNode node = (UserTreeNode)aavc.get(i);
			if( node.getParentId() == sysop.getGroupId() || node.getId() == sysop.getGroupId() )
				href= true;
			if( href ){
	%>
		-&gt; <a href="?catid=<%=catId%>&id=<%=node.getId()%>"><%=node.getName()%></a>
	<%
			}
			else{
	%>
		-&gt; <%=node.getName()%>
	<%	}
		}%>		
		&nbsp;&nbsp;
		</td>
  </tr>
 	<tr>
   	<td align="left">
   	 		<%=Language.getNameByCode("sys.role.groupprivilegelist","Group and Role and privilrge List")%><%=PageStr.getPageHead(totalUsers,pageid,pagerows,totalpages)%>
   	 		&nbsp;&nbsp;<% if(whereClause!=null && whereClause.length()>0) {%><a href="javascript:stopSearch();"><%=Language.getNameByCode("sys.clearsearch","Clear Search Condition")%></a><%}%>
   	</td>    	 
		<td align=right>
		<%		
		Vector groupList=ClassesDB.getChildrenByAsc(dbi,0,1,groupid);
		if(groupList.size()>0) { 
			out.print("<select name=\"groupid\" onChange=\"goUrl()\">");
			out.print("<option value=\"\">"+Language.getNameByCode("sys.plselect","Please Select")+"</option>");
			for(int i=0;i<groupList.size();i++) {
				Classes curclass=(Classes)groupList.get(i);
				out.print("<option value=\""+curclass.getId()+"\">"+curclass.getName()+"</option>");
			}
			out.print("</select>");
%>
<script language="javascript">
<!--
	function goUrl() {
		var index = document.formIon.groupid.selectedIndex;
		var v = document.formIon.groupid.options[index].value;
		location.href="?catid=<%=a%>&id="+v;
	}
-->
</script>
<%			
		}
		%>
     		<%=PageStr.PageForm(pageid,totalpages)%><input type="submit" name="Submit" value="go" style="width:0">
		</td>
  </tr>
</table>

	<TABLE border=0 cellPadding=0 cellSpacing=1 height="100%" width="100%">
		<input type="hidden" name="catid" value="<%=catId%>">
		<input type="hidden" name="id" value="<%=groupid%>">
		<input type="hidden" name="whereClause" value="<%=whereClause%>">
		<INPUT name="objid" type="hidden">
		<INPUT name="objtext" type="hidden">
		<INPUT name="objflag" type="hidden">
		<INPUT name="actionurl" type="hidden">
		<input type="hidden" name="orderfield" value="<%=orderfield%>">
		<input type="hidden" name="ordermode" value="<%=ordermode%>">
  	<TR>
    <TD>
   <%
    
   Table table=new Table();
   table.setSortMode(ordermode);
   table.setSortField(orderfield);
   table.setSelectionMode("multiple");

   table.addColumn("no","sys_class_role.iId",0,"center","left","number");
   table.addColumn(Language.getNameByCode("sys.sysop.id","ID"),"sys_class_role.iID",30,"center","left","number");
   table.addColumn(Language.getNameByCode("sys.class","Group"),"sys_class.name",80,"center","left","text");
   table.addColumn(Language.getNameByCode("sys.role","Role"),"sys_role.name",100,"center","left","text");
   table.addColumn(Language.getNameByCode("sys.category","Category"),"sys_class_role.icategoryid",380,"center","left","text");

    ArrayList rowsList=new ArrayList();
    try {
		Vector vc=GroupRole.getGroupRole(dbi,groupid,whereClause,pageid,pagerows,orderfield,ordermode);
		String rowData="";
		for(int i=0;i<vc.size();i++) {
			GroupRole gr=(GroupRole)vc.get(i);
			rowData=gr.getId()+"|"+gr.getId()+"|"+gr.getGroupName()+"|"+gr.getRoleName()+"|"+(Language.getNameByCode("sys.system","system")+Category.getCategoryNavigation(dbi,gr.getCategoryId(),"->"));
			rowsList.add(rowData);
		}
    } catch(Exception E) {
    }
    ArrayList menuList=new ArrayList();
    TableMenu tm=null;
    tm=new TableMenu(Language.getNameByCode("sys.role.addprivilege","Add Privilege Of User"),"JavaScript:Ion_Add();",true);
    menuList.add(tm);
    tm=new TableMenu(Language.getNameByCode("sys.Head.Refresh","Refresh"),"javascript:self.location.reload();",true);
    menuList.add(tm);
    tm=new TableMenu(Language.getNameByCode("sys.role.search","Search Private"),"javascript:Ion_Search();",false);
    menuList.add(tm);
    tm=new TableMenu(Language.getNameByCode("sys.role.deleteprivilege","Delete Privilege Of User"),"javascript:Ion_Del();",false);
    menuList.add(tm);
    table.setTableMenu(menuList);
    table.setRowsList(rowsList);
    TableDB tdb=new TableDB();
    out.print(tdb.draw(table));
    %>	
	
    </TD>
	</TR>
 	</FORM>
	</TABLE>
</body>
</html>
<%@ include file="../init_free.jsp" %>